Using  Formulas

You can make the value of a field equal to the result of a formula.  You may perform calculations with the Calc button, or have them performed automatically when you change the value of a field.

1.  Open the “Tutorial” database by tapping its icon in the Cabinet View.

2.  Turn to Page 4 by tapping the arrows at the bottom of the entry.

3.  Enter numbers in both the “Number 1” and “Number 2” fields.

4.  Press the Calc button, located to the right of the Mod button.  The sum of “Number 1” and “Number 2” appears in the field called “Formula Field”.

5.  Now tap the Action button in the upper right corner of the screen and select “Options” from the poplist.  The Entry Options View displays:

6.  Place a checkmark in the box marked “AutoCalc On” by tapping in it.

7.  Close the Entry Options View by tapping the close box in its lower right hand corner.

8.  Change a number in either the “Number 1” field or the “Number 2” field.  The new sum is automatically placed in the “Formula Field”.

9.  Tap Done to return to the Cabinet View.